<?
$conn=mysql_connect("localhost","root","root");   //建立与SQL Server数据库的连接
mysql_select_db("db_ee",$conn);   //选择数据库?>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>网站管理中心</title>
<meta name="Copyright" content="Douco Design." />
<link href="css/public.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="js/jquery.min.js"></script>
<script type="text/javascript" src="js/global.js"></script>
</head>
<body>
<div id="dcWrap"> <div id="dcHead">
 <div id="head">
  <div class="logo"><a href="index.html"><img src="images/dclogo.gif" alt="logo"></a></div>
  <div class="nav">
   <ul>
      <li><a href="search.php">查看模块</a></li>
    <li><a href="new.php">新建模块</a></li>
    <li><a href="edit.php">编辑模块</a></li>
	 <li><a href="delete.php">删除模块</a></li>
    <li><a href="">帮助</a></li>
    </ul>
   <ul class="navRight">
    <li class="M noLeft"><a href="JavaScript:void(0);">您好，admin</a>
       </li>
    <li class="noRight"><a href="login.php?rec=logout">退出</a></li>
   </ul>
  </div>
 </div>
</div>
<!-- dcHead 结束 --> <div id="dcLeft"><div id="menu">
 <!--<ul class="top">
  <li><a href="index.html"><i class="home"></i><em>管理首页</em></a></li>
 </ul>-->
  <ul>
    <li><a href="physical.php"><i class="show"></i><em>生理健康模块管理</em></a></li>
 </ul>
 <ul>
  <li><a href="emotion.php"><i class="page"></i><em>心理健康模块管理</em></a></li>
 </ul>
   <ul>
  <li><a href="talk.php"><i class="productCat"></i><em>专家模块管理</em></a></li>
 
 </ul>
  <ul>
  <li><a href="bk.php"><i class="articleCat"></i><em>百科模块管理</em></a></li>
  </ul>
   <ul>
  <li><a href="user.php"><i class="articleCat"></i><em>注册用户信息管理</em></a></li>
  </ul>
</div></div>
 <div id="dcMain"> <!-- 当前位置 -->
  <div id="index" class="mainBox" style="padding-top:18px;height:auto!important;height:550px;min-height:550px;">
   <table width="65%" border="0" cellspacing="0" cellpadding="0" class="indexBoxTwo">
    <tr>
     <td width="65%" valign="top" class="pr">
      <div class="indexBox">
       <div class="boxTitle">模块基本信息</div>
       <ul>
        <table width="100%" border="0" cellspacing="0" cellpadding="7" class="tableBasic">
         <tr>
		 <td width="20" align="center">用户名</td>
          <td width="20" align="center">运动步数</td>
          <td width="20" align="center">血压</td>
		 <td width="20" align="center">心率</td>
		  <td width="20" align="center">消耗能量</td>
		 <td width="20" align="center">体重</td>
		 <td width="20" align="center">睡眠状况</td>
          </tr>
	    
        <?php
		$link=mysql_connect("localhost","root","root") or die("不能连接到数据库服务器！可能是数据库服务器没有启动");
		$db_selected=mysql_select_db("db_ee",$link);
		mysql_query("set names utf8");
		$sql=mysql_query("select * from physical",$link);
		$info=mysql_fetch_array($sql);
		do{
		?>	
		<tr>
			<td width="20" align="center"><?php echo $info[username]?></td>
          <td width="20" align="center"><?php echo $info[sports]?></td>
          <td width="20" align="center"><?php echo $info[xy]?></td>
		 <td width="20" align="center"><?php echo $info[xl]?></td>
		  <td width="20" align="center"><?php echo $info[energy]?></td>
		 <td width="20" align="center"><?php echo $info[weight]?></td>
		 <td width="20" align="center"><?php echo $info[sleep]?></td>
		</tr>
		<?php
		}while($info=mysql_fetch_array($sql));
		
		?>
		</table>
       </ul>
      </div>
     </td>
     
    </tr>
   </table>
   </div>
	</div>
 </body>
</html>